package com.example.excelutildemo.entiry;

import com.alibaba.excel.annotation.ExcelIgnore;
import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.write.style.ColumnWidth;
import com.alibaba.excel.annotation.write.style.ContentLoopMerge;
import com.alibaba.excel.annotation.write.style.ContentRowHeight;
import com.alibaba.excel.annotation.write.style.HeadRowHeight;
import lombok.Data;

@Data
@ContentRowHeight(30)
@HeadRowHeight(20)
@ColumnWidth(25)
public class StockDateWeekMergeCell {
    @ExcelIgnore
    private Integer id;

    @ColumnWidth(50)
    @ContentLoopMerge(eachRow = 5)
    @ExcelProperty(value = {"基本信息", "股票代码"})
    private String stockCode;

    @ContentLoopMerge(eachRow = 5)
    @ExcelProperty(value = {"基本信息", "股票名称"})
    private String stockName;

    @ExcelProperty(value = {"价格信息", "开盘价"})
    private Double openPrice;

    @ExcelProperty({"价格信息", "收盘价"})
    private Double closePrice;

    @ExcelProperty({"价格信息", "最高价"})
    private Double highPrice;

    @ExcelProperty({"价格信息", "最低价"})
    private Double lowPrice;

    @ExcelProperty(value = {"价格信息", "涨跌幅"}, converter = DataConvert.class)
    private Double stockGain;

    @ExcelProperty({"价格信息", "成交量"})
    private Long volume;

    @ExcelProperty("所属市场")
    private String market;

    @ExcelProperty("日期")
    private String priceDate;

    @ExcelProperty("创建日期")
    private Long ctime;

    @ExcelIgnore
    private Long mtime;

}